Dataset info
| Number of variables | 94 |
|---|---|
| Number of observations | 137 |
| Missing cells | 1916 (14.9%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 100.7 KiB |
| Average record size in memory | 752.6 B |
Variables types
| Numeric | 3 |
|---|---|
| Categorical | 15 |
| Boolean | 4 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 72 |
| Unsupported | 0 |
Warnings
AGGR_POL_TERM_LIMIT_AMT has 39 (28.5%) missing values | Missing |
AMOUNT_CATEGORY_1_DESC has constant value "Premium" | Rejected |
AMOUNT_CATEGORY_2_DESC has constant value "Written" | Rejected |
AMOUNT_CATEGORY_3_DESC has constant value "nan" | Rejected |
ANNUAL_STMT_LINE_NAIC_CODE has constant value "90" | Rejected |
BLANKET_COVERAGE_IND has constant value "nan" | Rejected |
BUREAU_LINE_CODE has constant value "61" | Rejected |
BUREAU_REPORTING_MODULE has constant value "Inland Marine" | Rejected |
CANCEL_NO_RENEW_REASON_CODE has constant value "0" | Rejected |
CANCELLATION_TYPE has constant value "NON CANCEL" | Rejected |
CHANGE_WRITTEN_PREMIUM has 103 (75.2%) zeros | Zeros |
CLAIMS_MADE_IND has constant value "0" | Rejected |
CLASS_CODE has constant value "379" | Rejected |
CMRCL_DEREG_EXEMPT_IND has constant value "0" | Rejected |
COMPANY_CODE has constant value "1" | Rejected |
COUNTRY_CODE has constant value "CAN" | Rejected |
COVERAGE_INCEPTION_DATE has constant value "16-SEP-19" | Rejected |
CURRENT_PROFIT_CENTER has constant value "3542" | Rejected |
DEDUCT_AMT has 8 (5.8%) missing values | Missing |
DEDUCTIBLE_CODE is highly correlated with DEDUCT_AMT (ρ = 1) | Rejected |
DEDUCTIBLE_PURPOSE_DESC has 113 (82.5%) missing values | Missing |
EARN_EXPIRATION_DATE has constant value "16-SEP-20" | Rejected |
EXPENSE_MODIFIER has constant value "nan" | Rejected |
EXPIRATION_DATE has constant value "16-SEP-20" | Rejected |
EXPOSURE has 47 (34.3%) zeros | Zeros |
HSB_COVERAGE_CD has constant value "0" | Rejected |
INSURED_CITY_STATE has constant value "TORONTO, ON" | Rejected |
INSURED_NAME has constant value "BETA UAT PM QA TEST" | Rejected |
INSURED_ZIPCODE has constant value "111 BBB" | Rejected |
INTERNAL_ANNUAL_STMT_LINE_CODE has constant value "90" | Rejected |
INTERNAL_ANNUAL_STMT_LINE_CODE_1 has constant value "90" | Rejected |
ISO_PREMIUM_TERROR_CD has constant value "nan" | Rejected |
ISO_REPORTING_TERRITORY_CD has constant value "nan" | Rejected |
ISO_UNDERLYING_CD has 5 (3.6%) missing values | Missing |
LEGACY_PRO_CD has constant value "D" | Rejected |
LOCATION_UNIT_NUMBER is highly correlated with CONSTRUCTION_TYPE (ρ = 1) | Rejected |
LOSS_COST_MODIFIER has constant value "nan" | Rejected |
MINOR_LINE_CODE has constant value "90" | Rejected |
NAICS_CODE has constant value "236220" | Rejected |
NO_OF_FAMILIES has constant value "1" | Rejected |
NY_FREE_TRADE_ZONE_CD has constant value "0" | Rejected |
ONCORE_INDICATOR has constant value "BRIDGE-PAS" | Rejected |
PACKAGE_MODIFICATION_FACTOR has constant value "nan" | Rejected |
PER_OCCUR_LIMIT_AMT has 39 (28.5%) missing values | Missing |
POL_LIMIT_AMT has 39 (28.5%) missing values | Missing |
POLICY_EFFECTIVE_DATE has constant value "16-SEP-19" | Rejected |
POLICY_MODULE has constant value "0" | Rejected |
POLICY_NUMBER has constant value "2509018" | Rejected |
POLICY_STATE has constant value "82" | Rejected |
POLICY_STATUS has constant value "INFORCE" | Rejected |
POLICY_SYMBOL has constant value "IMP" | Rejected |
POLICY_TERM has constant value "12" | Rejected |
POLICY_VERSION_CD has constant value "0" | Rejected |
PREM_BILLING_CATEGORY_41_CODE has constant value "M" | Rejected |
PREM_TRNSCTN_CATEGORY_35_CODE is a recoding of BUSINESS_ACTIVITY_CODE | Rejected |
PREMIUM_TRNSCTN_DAC_CODE has constant value "1" | Rejected |
PRODUCER_A_CODE has constant value "264303" | Rejected |
PRODUCT_VALUE_1_8_CODE has constant value "2626AA04" | Rejected |
PROTECTION_CODE has constant value "0" | Rejected |
RATE_BASIS has 132 (96.4%) missing values | Missing |
RATE_DEPARTURE_FACTOR has constant value "0" | Rejected |
RATE_MOD_FACTOR_EXPENSE has constant value "0" | Rejected |
RATE_MOD_FACTOR_IRPM_SRP has constant value "0" | Rejected |
RATE_MOD_FACTOR_PACKAGE has constant value "0" | Rejected |
RATING_METHOD has 132 (96.4%) missing values | Missing |
RATING_TERRITORY_CD has constant value "nan" | Rejected |
REIN_TYPE_REPORTING_CATEGORY_1 has constant value "Direct" | Rejected |
SBP_BLANKET_IND has constant value "0" | Rejected |
SCHEDULE_MODIFIER has constant value "nan" | Rejected |
SIC_CODE has constant value "1542000D" | Rejected |
STAT_FORMAT_CODE has constant value "UIM" | Rejected |
STATE_PROVINCE_CODE has constant value "AB" | Rejected |
SUBLINE_CODE has constant value "920" | Rejected |
SURCHARGE_TYPE has constant value "nan" | Rejected |
SYSTEM_OF_RECORD_CODE has constant value "BRIDGE-PAS" | Rejected |
TAX_LOCATION_CODE has constant value "0" | Rejected |
TERRORISM_CVRG_CD has constant value "TERROR1" | Rejected |
TRANSACTION_ACCOUNTING_MONTH is highly correlated with SUBMISSION_ID (ρ = 0.9999978206) | Rejected |
TRANSACTION_ACCOUNTING_YEAR has constant value "2019" | Rejected |
TRANSACTION_EFFECTIVE_DATE only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
UNDERLYING_LIMIT_AMT has 39 (28.5%) missing values | Missing |
UNDERWRITER_CODE_1 has constant value "N" | Rejected |
UNDERWRITER_CODE_2 has constant value "N" | Rejected |
ZIP_CODE_FIRST5 has constant value "0" | Rejected |
AGGR_POL_TERM_LIMIT_AMT
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 28.5% |
| Missing (n) | 39 |
| 0 | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 98 | 71.5% | |
| (Missing) | 39 | 28.5% |
AMOUNT_CATEGORY_1_DESC
Constant
This variable is constant and should be ignored for analysis
| Constant value | Premium |
|---|
AMOUNT_CATEGORY_2_DESC
Constant
This variable is constant and should be ignored for analysis
| Constant value | Written |
|---|
AMOUNT_CATEGORY_3_DESC
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
ANNUAL_STMT_LINE_NAIC_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 90 |
|---|
BLANKET_COVERAGE_IND
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
BUREAU_LINE_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 61 |
|---|
BUREAU_REPORTING_MODULE
Constant
This variable is constant and should be ignored for analysis
| Constant value | Inland Marine |
|---|
BUSINESS_ACTIVITY_CODE
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ENDT | |
|---|---|
| NBP |
| Value | Count | Frequency (%) | |
| ENDT | 91 | 66.4% | |
| NBP | 46 | 33.6% |
| Max length | 4 |
|---|---|
| Mean length | 3.664233577 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
CANCEL_NO_RENEW_REASON_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
CANCELLATION_TYPE
Constant
This variable is constant and should be ignored for analysis
| Constant value | NON CANCEL |
|---|
CHANGE_WRITTEN_PREMIUM
Numeric
| Distinct count | 15 |
|---|---|
| Unique (%) | 10.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 57.48175182 |
|---|---|
| Minimum | -6836 |
| Maximum | 6836 |
| Zeros (%) | 75.2% |
Quantile statistics
| Minimum | -6836 |
|---|---|
| 5-th percentile | -100 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 120 |
| Maximum | 6836 |
| Range | 13672 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1295.670971 |
|---|---|
| Coef of variation | 22.54056166 |
| Kurtosis | 25.19035247 |
| Mean | 57.48175182 |
| MAD | 309.8074485 |
| Skewness | 0.9608413272 |
| Sum | 7875 |
| Variance | 1678763.266 |
| Memory size | 1.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 103 | 75.2% | |
| 100 | 8 | 5.8% | |
| 47 | 5 | 3.6% | |
| -100 | 4 | 2.9% | |
| -47 | 3 | 2.2% | |
| 250 | 2 | 1.5% | |
| 200 | 2 | 1.5% | |
| 6836 | 2 | 1.5% | |
| 95 | 2 | 1.5% | |
| -250 | 1 | 0.7% | |
| Other values (5) | 5 | 3.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -6836 | 1 | 0.7% | |
| -6637 | 1 | 0.7% | |
| -250 | 1 | 0.7% | |
| -200 | 1 | 0.7% | |
| -100 | 4 | 2.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 6836 | 2 | 1.5% | |
| 6637 | 1 | 0.7% | |
| 250 | 2 | 1.5% | |
| 200 | 2 | 1.5% | |
| 100 | 8 | 5.8% |
CLAIMS_MADE_IND
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
CLASS_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 379 |
|---|
CMRCL_DEREG_EXEMPT_IND
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
COMPANY_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 1 |
|---|
CONSTRUCTION_TYPE
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 3 | 5 |
| Value | Count | Frequency (%) | |
| 0 | 132 | 96.4% | |
| 3 | 5 | 3.6% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
COUNTRY_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | CAN |
|---|
COVERAGE_CODE
Categorical
| Distinct count | 30 |
|---|---|
| Unique (%) | 21.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| IMBRRES | 10 |
|---|---|
| TERROR | 5 |
| PLANRECS | 5 |
| Other values (27) |
| Value | Count | Frequency (%) | |
| IMBRRES | 10 | 7.3% | |
| TERROR | 5 | 3.6% | |
| PLANRECS | 5 | 3.6% | |
| IMBRRENV | 5 | 3.6% | |
| SCAFFOLDS | 5 | 3.6% | |
| REMOVALEXP | 5 | 3.6% | |
| GREEN | 5 | 3.6% | |
| BMP | 5 | 3.6% | |
| SOFTCOST | 5 | 3.6% | |
| INFLATION | 5 | 3.6% | |
| Other values (20) | 82 | 59.9% |
| Max length | 10 |
|---|---|
| Mean length | 7.160583942 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
COVERAGE_INCEPTION_DATE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 16-SEP-19 |
|---|
CURRENT_PROFIT_CENTER
Constant
This variable is constant and should be ignored for analysis
| Constant value | 3542 |
|---|
DEDUCT_AMT
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 2.2% |
| Missing (%) | 5.8% |
| Missing (n) | 8 |
| 0 | |
|---|---|
| 25000 | 16 |
| (Missing) | 8 |
| Value | Count | Frequency (%) | |
| 0 | 113 | 82.5% | |
| 25000 | 16 | 11.7% | |
| (Missing) | 8 | 5.8% |
| Max length | 7 |
|---|---|
| Mean length | 3.467153285 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
DEDUCT_APPLIES_TO
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 2.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| Each Loss | 14 |
| All other deductibles | 5 |
| Value | Count | Frequency (%) | |
| 0 | 113 | 82.5% | |
| Each Loss | 14 | 10.2% | |
| All other deductibles | 5 | 3.6% | |
| All Losses | 5 | 3.6% |
| Max length | 21 |
|---|---|
| Mean length | 2.875912409 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
DEDUCTIBLE_CODE
Highly correlated
This variable is highly correlated with DEDUCT_AMT and should be ignored for analysis
| Correlation | 1 |
|---|
DEDUCTIBLE_PURPOSE_DESC
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 82.5% |
| Missing (n) | 113 |
| (none) | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| (none) | 24 | 17.5% | |
| (Missing) | 113 | 82.5% |
| Max length | 6 |
|---|---|
| Mean length | 3.525547445 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
EARN_EXPIRATION_DATE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 16-SEP-20 |
|---|
EXPENSE_MODIFIER
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
EXPIRATION_DATE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 16-SEP-20 |
|---|
EXPOSURE
Numeric
| Distinct count | 17 |
|---|---|
| Unique (%) | 12.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 275 |
|---|---|
| Minimum | -7001 |
| Maximum | 7001 |
| Zeros (%) | 34.3% |
Quantile statistics
| Minimum | -7001 |
|---|---|
| 5-th percentile | -2200.2 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 50 |
| 95-th percentile | 7001 |
| Maximum | 7001 |
| Range | 14002 |
| Interquartile range | 50 |
Descriptive statistics
| Standard deviation | 2608.789152 |
|---|---|
| Coef of variation | 9.486506006 |
| Kurtosis | 4.262824086 |
| Mean | 275 |
| MAD | 1208.934307 |
| Skewness | 0.399475129 |
| Sum | 37675 |
| Variance | 6805780.838 |
| Memory size | 1.1 KiB |
| Value | Count | Frequency (%) | |
| 0 | 47 | 34.3% | |
| 100 | 14 | 10.2% | |
| 50 | 13 | 9.5% | |
| 7001 | 12 | 8.8% | |
| -100 | 9 | 6.6% | |
| -50 | 8 | 5.8% | |
| -7001 | 7 | 5.1% | |
| 25 | 5 | 3.6% | |
| 10 | 5 | 3.6% | |
| -25 | 3 | 2.2% | |
| Other values (7) | 14 | 10.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -7001 | 7 | 5.1% | |
| -1000 | 1 | 0.7% | |
| -600 | 1 | 0.7% | |
| -250 | 2 | 1.5% | |
| -100 | 9 | 6.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7001 | 12 | 8.8% | |
| 1000 | 2 | 1.5% | |
| 600 | 2 | 1.5% | |
| 250 | 3 | 2.2% | |
| 100 | 14 | 10.2% |
HSB_COVERAGE_CD
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
INSURED_CITY_STATE
Constant
This variable is constant and should be ignored for analysis
| Constant value | TORONTO, ON |
|---|
INSURED_NAME
Constant
This variable is constant and should be ignored for analysis
| Constant value | BETA UAT PM QA TEST |
|---|
INSURED_ZIPCODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 111 BBB |
|---|
INTERNAL_ANNUAL_STMT_LINE_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 90 |
|---|
INTERNAL_ANNUAL_STMT_LINE_CODE_1
Constant
This variable is constant and should be ignored for analysis
| Constant value | 90 |
|---|
ISO_PREMIUM_TERROR_CD
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
ISO_REPORTING_TERRITORY_CD
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
ISO_UNDERLYING_CD
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 3.6% |
| Missing (n) | 5 |
| 2 | |
|---|---|
| (Missing) | 5 |
| Value | Count | Frequency (%) | |
| 2 | 132 | 96.4% | |
| (Missing) | 5 | 3.6% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
LEGACY_PRO_CD
Constant
This variable is constant and should be ignored for analysis
| Constant value | D |
|---|
LOCATION_UNIT_NUMBER
Highly correlated
This variable is highly correlated with CONSTRUCTION_TYPE and should be ignored for analysis
| Correlation | 1 |
|---|
LOSS_COST_MODIFIER
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
MINOR_LINE_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 90 |
|---|
NAICS_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 236220 |
|---|
NO_OF_FAMILIES
Constant
This variable is constant and should be ignored for analysis
| Constant value | 1 |
|---|
NY_FREE_TRADE_ZONE_CD
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
ONCORE_INDICATOR
Constant
This variable is constant and should be ignored for analysis
| Constant value | BRIDGE-PAS |
|---|
ONSET_IND
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 84 | 61.3% | |
| 0 | 53 | 38.7% |
PACKAGE_CODE
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 26 | |
|---|---|
| 22 | 5 |
| Value | Count | Frequency (%) | |
| 26 | 132 | 96.4% | |
| 22 | 5 | 3.6% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
PACKAGE_MODIFICATION_FACTOR
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
PARENT_BUSN_CVRG_CD
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 4.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| IMBRPLUS | |
|---|---|
| IMBRRES | |
| IMBR | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| IMBRPLUS | 46 | 33.6% | |
| IMBRRES | 33 | 24.1% | |
| IMBR | 25 | 18.2% | |
| IMBRUILOB | 15 | 10.9% | |
| IMBRRENV | 10 | 7.3% | |
| TE | 8 | 5.8% |
| Max length | 9 |
|---|---|
| Mean length | 6.788321168 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
PER_OCCUR_LIMIT_AMT
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 28.5% |
| Missing (n) | 39 |
| 0 | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 98 | 71.5% | |
| (Missing) | 39 | 28.5% |
POL_LIMIT_AMT
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | 6.6% |
| Missing (%) | 28.5% |
| Missing (n) | 39 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1464275.316 |
|---|---|
| Minimum | 10000 |
| Maximum | 7000999 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 10000 |
|---|---|
| 5-th percentile | 10000 |
| Q1 | 50000 |
| Median | 100000 |
| Q3 | 512500 |
| 95-th percentile | 7000999 |
| Maximum | 7000999 |
| Range | 6990999 |
| Interquartile range | 462500 |
Descriptive statistics
| Standard deviation | 2735608.146 |
|---|---|
| Coef of variation | 1.868233464 |
| Kurtosis | 0.4552166227 |
| Mean | 1464275.316 |
| MAD | 2146892.857 |
| Skewness | 1.556139255 |
| Sum | 143498981 |
| Variance | 7.48355193e+12 |
| Memory size | 1.1 KiB |
| Value | Count | Frequency (%) | |
| 100000 | 31 | 22.6% | |
| 50000 | 21 | 15.3% | |
| 7000999 | 19 | 13.9% | |
| 25000 | 8 | 5.8% | |
| 10000 | 8 | 5.8% | |
| 250000 | 5 | 3.6% | |
| 600000 | 3 | 2.2% | |
| 1000000 | 3 | 2.2% | |
| (Missing) | 39 | 28.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 10000 | 8 | 5.8% | |
| 25000 | 8 | 5.8% | |
| 50000 | 21 | 15.3% | |
| 100000 | 31 | 22.6% | |
| 250000 | 5 | 3.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7000999 | 19 | 13.9% | |
| 1000000 | 3 | 2.2% | |
| 600000 | 3 | 2.2% | |
| 250000 | 5 | 3.6% | |
| 100000 | 31 | 22.6% |
POLICY_EFFECTIVE_DATE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 16-SEP-19 |
|---|
POLICY_MODULE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
POLICY_NUMBER
Constant
This variable is constant and should be ignored for analysis
| Constant value | 2509018 |
|---|
POLICY_STATE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 82 |
|---|
POLICY_STATUS
Constant
This variable is constant and should be ignored for analysis
| Constant value | INFORCE |
|---|
POLICY_SYMBOL
Constant
This variable is constant and should be ignored for analysis
| Constant value | IMP |
|---|
POLICY_TERM
Constant
This variable is constant and should be ignored for analysis
| Constant value | 12 |
|---|
POLICY_VERSION_CD
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
PREM_BILLING_CATEGORY_41_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | M |
|---|
PREM_TRNSCTN_CATEGORY_35_CODE
Recoded
This variable is a recoding of BUSINESS_ACTIVITY_CODE and should be ignored for analysis
PREMIUM_TRNSCTN_DAC_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 1 |
|---|
PRODUCER_A_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 264303 |
|---|
PRODUCT_VALUE_1_8_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 2626AA04 |
|---|
PROTECTION_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
RATE_BASIS
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 96.4% |
| Missing (n) | 132 |
| Other | 5 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| Other | 5 | 3.6% | |
| (Missing) | 132 | 96.4% |
| Max length | 5 |
|---|---|
| Mean length | 3.072992701 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
RATE_DEPARTURE_FACTOR
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
RATE_MOD_FACTOR_EXPENSE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
RATE_MOD_FACTOR_IRPM_SRP
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
RATE_MOD_FACTOR_PACKAGE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
RATING_METHOD
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 96.4% |
| Missing (n) | 132 |
| (none) | 5 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| (none) | 5 | 3.6% | |
| (Missing) | 132 | 96.4% |
| Max length | 6 |
|---|---|
| Mean length | 3.109489051 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
RATING_TERRITORY_CD
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
REIN_TYPE_REPORTING_CATEGORY_1
Constant
This variable is constant and should be ignored for analysis
| Constant value | Direct |
|---|
RISK_CATG_CD
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 2.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| COVPROP | |
|---|---|
| JOBSITE | |
| TIMELEMENT |
| Value | Count | Frequency (%) | |
| COVPROP | 79 | 57.7% | |
| JOBSITE | 25 | 18.2% | |
| TIMELEMENT | 18 | 13.1% | |
| BROPS | 15 | 10.9% |
| Max length | 10 |
|---|---|
| Mean length | 7.175182482 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
SBP_BLANKET_IND
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
SCHEDULE_MODIFIER
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
SIC_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 1542000D |
|---|
STAT_FORMAT_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | UIM |
|---|
STATE_PROVINCE_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | AB |
|---|
SUBLINE_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 920 |
|---|
SUBMISSION_ID
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 2.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 957051 | |
|---|---|
| 957039 | |
| 950041 |
| Value | Count | Frequency (%) | |
| 957051 | 60 | 43.8% | |
| 957039 | 54 | 39.4% | |
| 950041 | 23 | 16.8% |
| Max length | 6 |
|---|---|
| Mean length | 6 |
| Min length | 6 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SURCHARGE_TYPE
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
SYSTEM_OF_RECORD_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | BRIDGE-PAS |
|---|
TAX_LOCATION_CODE
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
TERRORISM_CVRG_CD
Constant
This variable is constant and should be ignored for analysis
| Constant value | TERROR1 |
|---|
TRANS_TYPE_CODE
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 2 | 5 |
| Value | Count | Frequency (%) | |
| 1 | 132 | 96.4% | |
| 2 | 5 | 3.6% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
TRANSACTION_ACCOUNTING_MONTH
Highly correlated
This variable is highly correlated with SUBMISSION_ID and should be ignored for analysis
| Correlation | 0.9999978206 |
|---|
TRANSACTION_ACCOUNTING_YEAR
Constant
This variable is constant and should be ignored for analysis
| Constant value | 2019 |
|---|
TRANSACTION_EFFECTIVE_DATE
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 16-SEP-19 | |
|---|---|
| 01-OCT-19 |
| Value | Count | Frequency (%) | |
| 16-SEP-19 | 77 | 56.2% | |
| 01-OCT-19 | 60 | 43.8% |
| Max length | 9 |
|---|---|
| Mean length | 9 |
| Min length | 9 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
UNDERLYING_LIMIT_AMT
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 28.5% |
| Missing (n) | 39 |
| 0 | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 98 | 71.5% | |
| (Missing) | 39 | 28.5% |
UNDERWRITER_CODE_1
Constant
This variable is constant and should be ignored for analysis
| Constant value | N |
|---|
UNDERWRITER_CODE_2
Constant
This variable is constant and should be ignored for analysis
| Constant value | N |
|---|
ZIP_CODE_FIRST5
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
First rows
| AGGR_POL_TERM_LIMIT_AMT | AMOUNT_CATEGORY_1_DESC | AMOUNT_CATEGORY_2_DESC | AMOUNT_CATEGORY_3_DESC | ANNUAL_STMT_LINE_NAIC_CODE | BLANKET_COVERAGE_IND | BUREAU_LINE_CODE | BUREAU_REPORTING_MODULE | BUSINESS_ACTIVITY_CODE | CANCEL_NO_RENEW_REASON_CODE | CANCELLATION_TYPE | CHANGE_WRITTEN_PREMIUM | CLAIMS_MADE_IND | CLASS_CODE | CMRCL_DEREG_EXEMPT_IND | COMPANY_CODE | CONSTRUCTION_TYPE | COUNTRY_CODE | COVERAGE_CODE | COVERAGE_INCEPTION_DATE | CURRENT_PROFIT_CENTER | DEDUCT_AMT | DEDUCT_APPLIES_TO | DEDUCTIBLE_CODE | DEDUCTIBLE_PURPOSE_DESC | EARN_EXPIRATION_DATE | EXPENSE_MODIFIER | EXPIRATION_DATE | EXPOSURE | HSB_COVERAGE_CD | INSURED_CITY_STATE | INSURED_NAME | INSURED_ZIPCODE | INTERNAL_ANNUAL_STMT_LINE_CODE | INTERNAL_ANNUAL_STMT_LINE_CODE_1 | ISO_PREMIUM_TERROR_CD | ISO_REPORTING_TERRITORY_CD | ISO_UNDERLYING_CD | LEGACY_PRO_CD | LOCATION_UNIT_NUMBER | LOSS_COST_MODIFIER | MINOR_LINE_CODE | NAICS_CODE | NO_OF_FAMILIES | NY_FREE_TRADE_ZONE_CD | ONCORE_INDICATOR | ONSET_IND | PACKAGE_CODE | PACKAGE_MODIFICATION_FACTOR | PARENT_BUSN_CVRG_CD | PER_OCCUR_LIMIT_AMT | POL_LIMIT_AMT | POLICY_EFFECTIVE_DATE | POLICY_MODULE | POLICY_NUMBER | POLICY_STATE | POLICY_STATUS | POLICY_SYMBOL | POLICY_TERM | POLICY_VERSION_CD | PREM_BILLING_CATEGORY_41_CODE | PREM_TRNSCTN_CATEGORY_35_CODE | PREMIUM_TRNSCTN_DAC_CODE | PRODUCER_A_CODE | PRODUCT_VALUE_1_8_CODE | PROTECTION_CODE | RATE_BASIS | RATE_DEPARTURE_FACTOR | RATE_MOD_FACTOR_EXPENSE | RATE_MOD_FACTOR_IRPM_SRP | RATE_MOD_FACTOR_PACKAGE | RATING_METHOD | RATING_TERRITORY_CD | REIN_TYPE_REPORTING_CATEGORY_1 | RISK_CATG_CD | SBP_BLANKET_IND | SCHEDULE_MODIFIER | SIC_CODE | STAT_FORMAT_CODE | STATE_PROVINCE_CODE | SUBLINE_CODE | SUBMISSION_ID | SURCHARGE_TYPE | SYSTEM_OF_RECORD_CODE | TAX_LOCATION_CODE | TERRORISM_CVRG_CD | TRANS_TYPE_CODE | TRANSACTION_ACCOUNTING_MONTH | TRANSACTION_ACCOUNTING_YEAR | TRANSACTION_EFFECTIVE_DATE | UNDERLYING_LIMIT_AMT | UNDERWRITER_CODE_1 | UNDERWRITER_CODE_2 | ZIP_CODE_FIRST5 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaN | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | NBP | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | IMBRRES | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 0 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBR | NaN | NaN | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | O | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | JOBSITE | 0 | NaN | 1542000D | UIM | AB | 920 | 950041 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 9 | 2019 | 16-SEP-19 | NaN | N | N | 0 |
| 1 | 0.0 | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | NBP | 0 | NON CANCEL | 6637 | 0 | 379 | 0 | 1 | 3 | CAN | IMBRRES | 16-SEP-19 | 3542 | 25000.0 | All Losses | 11 | (none) | 16-SEP-20 | NaN | 16-SEP-20 | 7001 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 1 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBR | 0.0 | 7000999.0 | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | O | 1 | 264303 | 2626AA04 | 0 | Other | 0 | 0 | 0 | 0 | (none) | NaN | Direct | JOBSITE | 0 | NaN | 1542000D | UIM | AB | 920 | 950041 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 9 | 2019 | 16-SEP-19 | 0.0 | N | N | 0 |
| 2 | 0.0 | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | NBP | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | ERROROM | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 50 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBRRENV | 0.0 | 50000.0 | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | O | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | COVPROP | 0 | NaN | 1542000D | UIM | AB | 920 | 950041 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 9 | 2019 | 16-SEP-19 | 0.0 | N | N | 0 |
| 3 | 0.0 | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | NBP | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | TEMPLOC | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 100 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBRPLUS | 0.0 | 100000.0 | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | O | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | COVPROP | 0 | NaN | 1542000D | UIM | AB | 920 | 950041 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 9 | 2019 | 16-SEP-19 | 0.0 | N | N | 0 |
| 4 | 0.0 | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | NBP | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | TEMPSTRTR | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 100 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBRPLUS | 0.0 | 100000.0 | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | O | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | COVPROP | 0 | NaN | 1542000D | UIM | AB | 920 | 950041 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 9 | 2019 | 16-SEP-19 | 0.0 | N | N | 0 |
| 5 | NaN | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | NBP | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | TE | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 0 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBRPLUS | NaN | NaN | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | O | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | TIMELEMENT | 0 | NaN | 1542000D | UIM | AB | 920 | 950041 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 9 | 2019 | 16-SEP-19 | NaN | N | N | 0 |
| 6 | 0.0 | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | NBP | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | GREEN | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 250 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBR | 0.0 | 250000.0 | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | O | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | JOBSITE | 0 | NaN | 1542000D | UIM | AB | 920 | 950041 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 9 | 2019 | 16-SEP-19 | 0.0 | N | N | 0 |
| 7 | 0.0 | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | NBP | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | TREES | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 100 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBRRES | 0.0 | 100000.0 | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | O | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | COVPROP | 0 | NaN | 1542000D | UIM | AB | 920 | 950041 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 9 | 2019 | 16-SEP-19 | 0.0 | N | N | 0 |
| 8 | 0.0 | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | NBP | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | REMOVALEXP | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 100 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBRPLUS | 0.0 | 100000.0 | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | O | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | COVPROP | 0 | NaN | 1542000D | UIM | AB | 920 | 950041 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 9 | 2019 | 16-SEP-19 | 0.0 | N | N | 0 |
| 9 | 0.0 | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | NBP | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | SCAFFOLDS | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 100 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBRPLUS | 0.0 | 100000.0 | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | O | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | COVPROP | 0 | NaN | 1542000D | UIM | AB | 920 | 950041 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 9 | 2019 | 16-SEP-19 | 0.0 | N | N | 0 |
Last rows
| AGGR_POL_TERM_LIMIT_AMT | AMOUNT_CATEGORY_1_DESC | AMOUNT_CATEGORY_2_DESC | AMOUNT_CATEGORY_3_DESC | ANNUAL_STMT_LINE_NAIC_CODE | BLANKET_COVERAGE_IND | BUREAU_LINE_CODE | BUREAU_REPORTING_MODULE | BUSINESS_ACTIVITY_CODE | CANCEL_NO_RENEW_REASON_CODE | CANCELLATION_TYPE | CHANGE_WRITTEN_PREMIUM | CLAIMS_MADE_IND | CLASS_CODE | CMRCL_DEREG_EXEMPT_IND | COMPANY_CODE | CONSTRUCTION_TYPE | COUNTRY_CODE | COVERAGE_CODE | COVERAGE_INCEPTION_DATE | CURRENT_PROFIT_CENTER | DEDUCT_AMT | DEDUCT_APPLIES_TO | DEDUCTIBLE_CODE | DEDUCTIBLE_PURPOSE_DESC | EARN_EXPIRATION_DATE | EXPENSE_MODIFIER | EXPIRATION_DATE | EXPOSURE | HSB_COVERAGE_CD | INSURED_CITY_STATE | INSURED_NAME | INSURED_ZIPCODE | INTERNAL_ANNUAL_STMT_LINE_CODE | INTERNAL_ANNUAL_STMT_LINE_CODE_1 | ISO_PREMIUM_TERROR_CD | ISO_REPORTING_TERRITORY_CD | ISO_UNDERLYING_CD | LEGACY_PRO_CD | LOCATION_UNIT_NUMBER | LOSS_COST_MODIFIER | MINOR_LINE_CODE | NAICS_CODE | NO_OF_FAMILIES | NY_FREE_TRADE_ZONE_CD | ONCORE_INDICATOR | ONSET_IND | PACKAGE_CODE | PACKAGE_MODIFICATION_FACTOR | PARENT_BUSN_CVRG_CD | PER_OCCUR_LIMIT_AMT | POL_LIMIT_AMT | POLICY_EFFECTIVE_DATE | POLICY_MODULE | POLICY_NUMBER | POLICY_STATE | POLICY_STATUS | POLICY_SYMBOL | POLICY_TERM | POLICY_VERSION_CD | PREM_BILLING_CATEGORY_41_CODE | PREM_TRNSCTN_CATEGORY_35_CODE | PREMIUM_TRNSCTN_DAC_CODE | PRODUCER_A_CODE | PRODUCT_VALUE_1_8_CODE | PROTECTION_CODE | RATE_BASIS | RATE_DEPARTURE_FACTOR | RATE_MOD_FACTOR_EXPENSE | RATE_MOD_FACTOR_IRPM_SRP | RATE_MOD_FACTOR_PACKAGE | RATING_METHOD | RATING_TERRITORY_CD | REIN_TYPE_REPORTING_CATEGORY_1 | RISK_CATG_CD | SBP_BLANKET_IND | SCHEDULE_MODIFIER | SIC_CODE | STAT_FORMAT_CODE | STATE_PROVINCE_CODE | SUBLINE_CODE | SUBMISSION_ID | SURCHARGE_TYPE | SYSTEM_OF_RECORD_CODE | TAX_LOCATION_CODE | TERRORISM_CVRG_CD | TRANS_TYPE_CODE | TRANSACTION_ACCOUNTING_MONTH | TRANSACTION_ACCOUNTING_YEAR | TRANSACTION_EFFECTIVE_DATE | UNDERLYING_LIMIT_AMT | UNDERWRITER_CODE_1 | UNDERWRITER_CODE_2 | ZIP_CODE_FIRST5 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 127 | 0.0 | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | ENDT | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | GREEN | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 250 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBR | 0.0 | 250000.0 | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | E | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | JOBSITE | 0 | NaN | 1542000D | UIM | AB | 920 | 957051 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 10 | 2019 | 01-OCT-19 | 0.0 | N | N | 0 |
| 128 | 0.0 | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | ENDT | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | TEMPSTRTR | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 100 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBRPLUS | 0.0 | 100000.0 | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | E | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | COVPROP | 0 | NaN | 1542000D | UIM | AB | 920 | 957051 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 10 | 2019 | 01-OCT-19 | 0.0 | N | N | 0 |
| 129 | 0.0 | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | ENDT | 0 | NON CANCEL | 250 | 0 | 379 | 0 | 1 | 0 | CAN | ADDLIVEXP | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 10 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBRRES | 0.0 | 10000.0 | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | E | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | COVPROP | 0 | NaN | 1542000D | UIM | AB | 920 | 957051 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 10 | 2019 | 01-OCT-19 | 0.0 | N | N | 0 |
| 130 | 0.0 | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | ENDT | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | TEMPLOC | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 100 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBRPLUS | 0.0 | 100000.0 | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | E | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | COVPROP | 0 | NaN | 1542000D | UIM | AB | 920 | 957051 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 10 | 2019 | 01-OCT-19 | 0.0 | N | N | 0 |
| 131 | 0.0 | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | ENDT | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | SCAFFOLDS | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 100 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBRPLUS | 0.0 | 100000.0 | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | E | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | COVPROP | 0 | NaN | 1542000D | UIM | AB | 920 | 957051 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 10 | 2019 | 01-OCT-19 | 0.0 | N | N | 0 |
| 132 | NaN | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | ENDT | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | BMP | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 0 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBRUILOB | NaN | NaN | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | E | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | BROPS | 0 | NaN | 1542000D | UIM | AB | 920 | 957051 | NaN | BRIDGE-PAS | 0 | TERROR1 | 2 | 10 | 2019 | 01-OCT-19 | NaN | N | N | 0 |
| 133 | 0.0 | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | ENDT | 0 | NON CANCEL | 47 | 0 | 379 | 0 | 1 | 0 | CAN | SOFTCOST | 16-SEP-19 | 3542 | NaN | Each Loss | 1 | (none) | 16-SEP-20 | NaN | 16-SEP-20 | 0 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | TE | 0.0 | 100000.0 | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | E | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | TIMELEMENT | 0 | NaN | 1542000D | UIM | AB | 920 | 957051 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 10 | 2019 | 01-OCT-19 | 0.0 | N | N | 0 |
| 134 | NaN | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | ENDT | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | TERROR | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 0 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | NaN | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 22 | NaN | IMBRUILOB | NaN | NaN | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | E | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | BROPS | 0 | NaN | 1542000D | UIM | AB | 920 | 957051 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 10 | 2019 | 01-OCT-19 | NaN | N | N | 0 |
| 135 | NaN | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | ENDT | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | TE | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 0 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBRPLUS | NaN | NaN | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | E | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | TIMELEMENT | 0 | NaN | 1542000D | UIM | AB | 920 | 957051 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 10 | 2019 | 01-OCT-19 | NaN | N | N | 0 |
| 136 | NaN | Premium | Written | NaN | 90 | NaN | 61 | Inland Marine | ENDT | 0 | NON CANCEL | 0 | 0 | 379 | 0 | 1 | 0 | CAN | IMBRRES | 16-SEP-19 | 3542 | 0.0 | 0 | 1 | NaN | 16-SEP-20 | NaN | 16-SEP-20 | 0 | 0 | TORONTO, ON | BETA UAT PM QA TEST | 111 BBB | 90 | 90 | NaN | NaN | 2.0 | D | 0 | NaN | 90 | 236220 | 1 | 0 | BRIDGE-PAS | 1 | 26 | NaN | IMBR | NaN | NaN | 16-SEP-19 | 0 | 2509018 | 82 | INFORCE | IMP | 12 | 0 | M | E | 1 | 264303 | 2626AA04 | 0 | NaN | 0 | 0 | 0 | 0 | NaN | NaN | Direct | JOBSITE | 0 | NaN | 1542000D | UIM | AB | 920 | 957051 | NaN | BRIDGE-PAS | 0 | TERROR1 | 1 | 10 | 2019 | 01-OCT-19 | NaN | N | N | 0 |